package com.eascs.workflow.org.dao.impl;

import java.util.List;
import org.springframework.stereotype.Repository;
import com.eascs.workflow.common.dao.BaseDao;
import com.eascs.workflow.org.dao.OrganRoleUserDao;
import com.eascs.workflow.org.entity.OrgRoleUser;

@Repository
public class OrganRoleUserDaoImpl extends BaseDao implements OrganRoleUserDao {

	@Override
	public List<OrgRoleUser> getOrganRoleUser(String organId,String roleId) {
		String sql = "select t.id ,t.org_id as orgId,t.org_name as orgName,t.role_id as roleId,t.role_name as roleName,t.user_no as userNo,"
				+ "t.user_name as userName from act_org_role_user t where t.org_id = ? and t.role_id = ? and t.is_remove = 0";
		return this.workflowJdbcSession.findEntitys(sql, OrgRoleUser.class, organId,roleId);
	}
}
